Overview

Tax Submission is used to generate the "Employer Monthly Submission (EMS)"  file. The EMS file contains PAYE lodgements for a period which is submitted to "Fiji Revenue and Customs Services (FRCS)".

FRCS File format Specification

The following file formats are available:

1. Pay Day - Auto-Calculate Payday Report File Format
2. Pay Day Manual - Manual Tax Input Payday Report File Format
3. Pre ECAL - Pre-ECAL EMS Excel File Format
4. Post ECAL - Post-ECAL EMS Excel File Format
5. EMS File format prior to Jan 2021  

Steps to configure the FRCS File

1. Configure the file extension in menu "Integration -> Integration Setup -> TaxSuperFile -> FileExtension"
   1. Pay Day: csv
   2. Pay Day Manual: csv
   3. PreE CAL: csv
   4. Post ECAL: csv
   5. EMS File format prior to Jan 2020: txt
2. Enter the "Branch" in menu "Global Administration -> Company -> Notes and Attachments -> Additional Fields"
   "Branch" - This is the branch number supplied by FRCS. This is used by the FRCS file to format the filename.
3. Enter the "Gross-Up" for each employee in menu "Employee Profile -> Employee Maintenance -> Notes and Attachments -> Additional Fields"

Pre-requisites

1. Enable the "Integration Scheduler" in menu "Global Administration -> Process Setup "
2. Enable integration for "PAYTaxFile" under "Linkweb - Integration - Integration Setup ".

Steps to create Tax File Submission:

1. Add a New Record
2. Enter below details:
   1. Date - Select the submission date.
   2. Tax File Format :
      1. Pay Day
      2. Pay Day Manual
      3. Pre ECAL
      4. Post ECAL
      5. EMS File format prior to Jan 2020.
   3. Consolidate - If "Ticked" will consolidate the tax values from all companies with the same Tax File Number. 

Steps to generate the excel output file for Tax Submission:

Option 1 - Use the File attached to the "Tax Submission" record

1. Expand the "Tax Submission Record"
2. Select the "Attachments" tab. A file will be available once the "Tax Submission" status is "Completed"
3. Upload this file to the Tax portal

Option 2 - Use the File export to create an Excel Output File

1. Once the "Tax Submission" record is completed, click on the "View" link next to the status.
2. From the grid displayed, click on the "Export to XLSX" option to download the excel file.
3. Open the exported file in "MS Excel" application and format the date columns to "DD/MM/YYYY". Once the changes are done, save the file then upload it to your tax payer portal.

Notes

1. A background process will execute and generate the EMS file. This file will be attached as an attachment in the details. The file will also be emailed to the "Email Address" configured under "PayTaxFile" integration.
2. Values in the file can be validated against the "Tax Reconciliation Report".